﻿<?php
    echo "<!DOCTYPE html>\n";
    include 'inc/conn.php';
    $pageSize = 20;
    $phpself =$_SERVER['PHP_SELF'];
    $pagestr = end(explode("/",$phpself));
    
    extract($_POST);
    extract($_GET);
    unset($_POST,$_GET);
?>
<html lang="en">
<head>
<title>工程知识系统</title>
<meta http-equiv="content-type" content="text/html;charset=utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<!-- <link rel="stylesheet" href="https://cdn.staticfile.org/twitter-bootstrap/3.3.7/css/bootstrap.min.css">-->
<link rel="stylesheet" href="/css/bootstrap.min.css">
<!-- HTML5 shim and Respond.js for IE8 support of HTML5 elements and media queries -->
<!-- WARNING: Respond.js doesn't work if you view the page via file:// -->
<!--[if lt IE 9]>
  <script src="https://oss.maxcdn.com/html5shiv/3.7.3/html5shiv.min.js"></script>
  <script src="https://oss.maxcdn.com/respond/1.4.2/respond.min.js"></script>
<![endif]-->
<script src="/js/jquery.min.js"></script>
<script src="/js/bootstrap.min.js"></script>
<script type="text/javascript">  
function goTopEx() {  
    var obj = document.getElementById("goTopBtn");  
    function getScrollTop() {  
        return document.documentElement.scrollTop + document.body.scrollTop;  
    }  
    function setScrollTop(value) {  
        if (document.documentElement.scrollTop) {  
            document.documentElement.scrollTop = value;  
        } else {  
            document.body.scrollTop = value;  
        }  
    }  
    window.onscroll = function() {  
        getScrollTop() > 0 ? obj.style.display = "": obj.style.display = "none";  
    }  
    obj.onclick = function() {  
        var goTop = setInterval(scrollMove, 10);  
        function scrollMove() {  
            setScrollTop(getScrollTop() / 1.1);  
            if (getScrollTop() < 1) clearInterval(goTop);  
        }  
    }  
}  
	function   Go(it)   {   
		window.location="<? echo $pagestr ?>?page="+it.value;
	}
	
	$(function(){
		$("#ad").click(function(){
			$("#ad").hide();
		});
		
	});
</script>

<style>
	BODY {  
		HEIGHT: auto;  
	}  
	#goTopBtn {  
		POSITION: fixed; TEXT-ALIGN: center; LINE-HEIGHT: 30px; WIDTH: 30px; BOTTOM: 35px; 
		HEIGHT: 33px; FONT-SIZE: 12px; CURSOR: pointer; RIGHT: 0px; _position: absolute; _right: auto  
	}  
</style>
</head>
<body class="background">
<div style="display: none" id="goTopBtn"><img border=0 src="/image/top.jpg"></div>
<script type=text/javascript>goTopEx();</script>
<?
	include "top.php";
?>
<div class="container-fluid">
	<div id="ad">
	<marquee direction="left" scrollamount="2" scrolldelay="60">
	<p class="text-primary">
	<span class="glyphicon glyphicon-bullhorn"></span> 
	<?
		$db = new mysql();
		$db->query("select * from eng_ad ORDER BY build_date DESC limit 10");
		$num = $db->db_num_rows();
		for($i=0; $i<$num; $i++){
			$row = $db->fetch_assoc();
			echo "[ <b>".substr($row['BUILD_DATE'],0,10).":</b> ".$row['AD_BODY']." ] ";
		}
		$db->close();
	?>
	</p>
	</marquee>
	</div>
	<div style="width:50%; height:auto; float:left; display:inline">
		<div class="panel panel-primary">
			<div class="panel-heading">
				<h3 class="panel-title">
					<span class="glyphicon glyphicon-question-sign"></span> 问题追踪系统 <a href="issue_list.php">[More...]</a>
				</h3>
			</div>
			<div class="panel-body">
				<div>
					<? 
							$db = new mysql();
							$db->query("select * from validate_issues ORDER BY val_date DESC limit 10");
							$num = $db->db_num_rows();
							for($i=0; $i<$num; $i++){
								$row = $db->fetch_assoc();
								echo "<img src=\"image/new.png\"><a href=\"review_issue.php?id=".$row['id']."\">".htmlspecialchars_decode($row['val_reason'])."</a>";
								echo "        ".$row['val_owner']." ";
								echo "        ".$row['val_status']."</br>";
							}
					?>
				</div>
			</div>
		</div>

		<div class="panel panel-primary">
			<div class="panel-heading">
				<h3 class="panel-title">
					<span class="glyphicon glyphicon-globe"></span> 工程维基系统 <a href="tewiki.php">[More...]</a> 
				</h3>
			</div>
			<div class="panel-body">
				<div>
					<? 
							$db->query("select * from te_wiki_table ORDER BY wiki_build_date DESC limit 10");
							$num = $db->db_num_rows();
							for($i=0; $i<$num; $i++){
								$row = $db->fetch_assoc();
								echo "<img src=\"image/new.png\"><a href=\"review_wiki.php?id=".$row['ID']."\">".htmlspecialchars_decode($row['wiki_title'])."</a>";
								echo "        ".$row['wiki_writor']."</br>";
							}
					?>
				</div>
			</div>
		</div>
		<div class="panel panel-primary">
			<div class="panel-heading">
				<h3 class="panel-title">
					<span class="glyphicon glyphicon-fire"></span> 异常数据收集 <a href="err_list.php">[More...]</a> 
				</h3>
			</div>
			<div class="panel-body">
				<div>
					<? 
							$db->query("select * from Error_Collect ORDER BY add_date DESC limit 10");
							$num = $db->db_num_rows();
							for($i=0; $i<$num; $i++){
								$row = $db->fetch_assoc();
								echo "<img src=\"image/new.png\"> ${row['ErrMsg']},${row['add_date']}</br>";
							}
					?>
				</div>
			</div>
		</div>
	</div>
	<div style="width:50%; height:auto; float:left; display:inline">
		<div class="panel panel-primary">
			<div class="panel-heading">
				<h3 class="panel-title">
					<span class="glyphicon glyphicon-list-alt"></span> 版本管控系统 <a href="versionlist.php">[More...]</a> 
				</h3>
			</div>
			<div class="panel-body">
				<div>
					<? 
							$db->query("select * from eng_version_control_table ORDER BY build_date DESC limit 10");
							$num = $db->db_num_rows();
							for($i=0; $i<$num; $i++){
								$row = $db->fetch_assoc();
								echo "<img src=\"image/new.png\"><a href=\"review_verlist.php?id=".$row['ID']."\">".htmlspecialchars_decode($row['Model_name'])."</a>";
								echo " ".htmlspecialchars_decode($row['Customer'])." ";
								echo " ".htmlspecialchars_decode($row['BIOS_version'])." ";
								echo " ".htmlspecialchars_decode($row['EC_version'])." ";
								echo " ".htmlspecialchars_decode($row['Owner'])." ";
								if ($row['Q_result']== 1)
									echo " <font color='green'>通过</font></br>";
								else
									echo " <font color='blue'>待测</font></br>";
							}
					?>
				</div>
			</div>
		</div>

		<div class="panel panel-primary">
			<div class="panel-heading">
				<h3 class="panel-title">
					<span class="glyphicon glyphicon-shopping-cart"></span> 库存管控系统 <a href="repo_list.php">[More...]</a>
				</h3>
			</div>
			<div class="panel-body">
				<div>
					<? 
							$db->query("select * from eng_repo ORDER BY KP_CHECKIN_DATE DESC limit 10");
							$num = $db->db_num_rows();
							for($i=0; $i<$num; $i++){
								$row = $db->fetch_assoc();
								echo "<img src=\"image/new.png\">".htmlspecialchars_decode($row['KP_PN'])." ";
								echo " ".htmlspecialchars_decode($row['KP_NUM'])." ";
								echo " ".htmlspecialchars_decode($row['DEPT'])." ";
								echo " ".htmlspecialchars_decode($row['KP_OWNER']);
								echo " ".htmlspecialchars_decode($row['STATUS'])."</br>";
							}
					?>
				</div>
			</div>
		</div>

		<div class="panel panel-primary">
			<div class="panel-heading">
				<h3 class="panel-title">
					<span class="glyphicon glyphicon-flag"></span> 产线工单首件 <a href="wo_list.php">[More...]</a>
				</h3>
			</div>
			<div class="panel-body">
				<div>
					<? 
							$db->query("select * from mfg_wo ORDER BY add_date DESC limit 10");
							$num = $db->db_num_rows();
							for($i=0; $i<$num; $i++){
								$row = $db->fetch_assoc();
								echo "<img src=\"image/new.png\">".htmlspecialchars_decode($row['PARTNUM'])." ";
								echo " ".htmlspecialchars_decode($row['WO'])." ";
								echo " ".htmlspecialchars_decode($row['LINE'])." ";
								echo " ".htmlspecialchars_decode($row['add_date']);
								echo " ".htmlspecialchars_decode($row['FLAG'])."</br>";
							}
					?>
				</div>
			</div>
		</div>

		<div class="panel panel-primary">
			<div class="panel-heading">
				<h3 class="panel-title">
					<span class="glyphicon glyphicon-flag"></span> DPK机器数据 <a href="dpk_list.php">[More...]</a>
				</h3>
			</div>
			<div class="panel-body">
				<div>
					<? 
							$db->query("select * from sn_uuid ORDER BY add_date DESC limit 10");
							$num = $db->db_num_rows();
							for($i=0; $i<$num; $i++){
								$row = $db->fetch_assoc();
								echo "<img src=\"image/new.png\">".htmlspecialchars_decode($row['SN'])." ";
								echo " ".htmlspecialchars_decode($row['PN']);
								echo " ".htmlspecialchars_decode($row['UUID']);
								echo " ".substr(htmlspecialchars_decode($row['add_date']),0,10)."</br>";
							}
					?>
				</div>
			</div>
		</div>
</div>
</div>
<?
include 'bottom.php';
?>
</body>
</html>
<?  
	$db->close();
?>
